package com.nut.spp.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.nut.spp.entity.OrderGoods;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface OrderGoodsMapper extends BaseMapper<OrderGoods> {

//    @Select("select * from biz_order_goods where order_id=#{orderId} and deleted=0")
//    List<OrderGoods> selectByOrderId(@Param("orderId") Long orderId);

    @Select("select * from biz_order_goods where order_id=#{orderId} and deleted=0 limit 1")
    OrderGoods selectByOrderId(@Param("orderId") String orderId);

}